CREATE TABLE  "SDR_CONTENT_TYPE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_CONTENT_TYPE_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_CONTENT" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"FILE_NAME" VARCHAR2(1000) NOT NULL ENABLE, 
	"DATA" BLOB, 
	"CONTENT_TYPE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_CONTENT_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_CONTENT_SDR_CONTENT_T_FK1" FOREIGN KEY ("CONTENT_TYPE_ID")
	  REFERENCES  "SDR_CONTENT_TYPE" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_DOCUMENT_TYPE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_DOCUMENT_TYPE_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_TYPE_UK1" UNIQUE ("CODE") ENABLE
   )
/
CREATE TABLE  "SDR_LANGUAGE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(3) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_LANGUAGE_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_LANGUAGE_UK1" UNIQUE ("CODE") ENABLE
   )
/
CREATE TABLE  "SDR_DOCUMENT" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"TITLE" VARCHAR2(50), 
	"DESCRIPTION" VARCHAR2(500), 
	"CONTENT_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"REFERENCE" VARCHAR2(1000), 
	"DOCUMENT_TYPE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"LANGUAGE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ORIGINAL_ID" NUMBER(*,0), 
	 CONSTRAINT "SDR_DOCUMENT_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_SDR_DOCUMENT_FK1" FOREIGN KEY ("CONTENT_ID")
	  REFERENCES  "SDR_CONTENT" ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_SDR_DOCUMENT_FK2" FOREIGN KEY ("DOCUMENT_TYPE_ID")
	  REFERENCES  "SDR_DOCUMENT_TYPE" ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_SDR_LANGUAGE_FK1" FOREIGN KEY ("LANGUAGE_ID")
	  REFERENCES  "SDR_LANGUAGE" ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_SDR_DOCUMENT_FK3" FOREIGN KEY ("ORIGINAL_ID")
	  REFERENCES  "SDR_DOCUMENT" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_ANNOTATION" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"DOCUMENT_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"DESCRIPTOR" CLOB, 
	"ANNOTATION_TYPE_ID" NUMBER(*,0), 
	"CONTENT_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"LANGUAGE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_SDR_DOCUME_FK1" FOREIGN KEY ("DOCUMENT_ID")
	  REFERENCES  "SDR_DOCUMENT" ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_SDR_LANGUA_FK1" FOREIGN KEY ("LANGUAGE_ID")
	  REFERENCES  "SDR_LANGUAGE" ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_SDR_CONTEN_FK1" FOREIGN KEY ("CONTENT_ID")
	  REFERENCES  "SDR_CONTENT" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_ANNOTATION_STATUS" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_UK1" UNIQUE ("CODE") ENABLE
   )
/
CREATE TABLE  "SDR_PERSON" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"NAME" VARCHAR2(50) NOT NULL ENABLE, 
	"SURNAME" VARCHAR2(4000) NOT NULL ENABLE, 
	"LOGIN" VARCHAR2(50) NOT NULL ENABLE, 
	"EMAIL" VARCHAR2(50) NOT NULL ENABLE, 
	"PASSWORD_HASH" VARCHAR2(50), 
	 CONSTRAINT "SDR_PERSON_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_ANNOTATION_STATUS_HISTORY" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ANNOTATION_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ANNOTATION_STATUS_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ADATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"PERSON_ID" NUMBER(*,0) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_HIS_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_HIS_FK1" FOREIGN KEY ("ANNOTATION_ID")
	  REFERENCES  "SDR_ANNOTATION" ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_HIS_FK2" FOREIGN KEY ("ANNOTATION_STATUS_ID")
	  REFERENCES  "SDR_ANNOTATION_STATUS" ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_STATUS_HIS_FK3" FOREIGN KEY ("PERSON_ID")
	  REFERENCES  "SDR_PERSON" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_ANNOTATION_TYPE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_ANNOTATION_TYPE_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_ANNOTATION_TYPE_UK1" UNIQUE ("CODE") ENABLE
   )
/
CREATE TABLE  "SDR_CONTENT_STATUS" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_CONTENT_STATUS_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_DOCUMENT_STATUS" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_DOCUMENT_STATUS_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_CONTENT_STATUS_HISTORY" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CONTENT_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CONTENT_STATUS_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ADATE" TIMESTAMP (6) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_CONTENT_STATUS_HISTOR_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_CONTENT_STATUS_HISTOR_FK1" FOREIGN KEY ("CONTENT_ID")
	  REFERENCES  "SDR_CONTENT" ("ID") ENABLE, 
	 CONSTRAINT "SDR_CONTENT_STATUS_HISTOR_FK2" FOREIGN KEY ("CONTENT_STATUS_ID")
	  REFERENCES  "SDR_DOCUMENT_STATUS" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_DOCUMENT_STATUS_HISTORY" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"DOCUMENT_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"DOCUMENT_STATUS_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ADATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"PERSON_ID" NUMBER(*,0) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_STATUS_HISTO_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_STATUS_HISTO_FK1" FOREIGN KEY ("DOCUMENT_ID")
	  REFERENCES  "SDR_DOCUMENT" ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_STATUS_HISTO_FK2" FOREIGN KEY ("DOCUMENT_STATUS_ID")
	  REFERENCES  "SDR_DOCUMENT_STATUS" ("ID") ENABLE, 
	 CONSTRAINT "SDR_DOCUMENT_STATUS_HISTO_FK3" FOREIGN KEY ("PERSON_ID")
	  REFERENCES  "SDR_PERSON" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_PERSON_STATUS" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_PERSON_STATUS_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_PERSON_STATUS_UK1" UNIQUE ("CODE") ENABLE
   )
/
CREATE TABLE  "SDR_PERSON_STATUS_HISTORY" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PERSON_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PERSON_STATUS_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ADATE" TIMESTAMP (6) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_PERSON_STATUS_HISTORY_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_PERSON_STATUS_HISTORY_FK1" FOREIGN KEY ("PERSON_ID")
	  REFERENCES  "SDR_PERSON" ("ID") ENABLE, 
	 CONSTRAINT "SDR_PERSON_STATUS_HISTORY_FK2" FOREIGN KEY ("PERSON_STATUS_ID")
	  REFERENCES  "SDR_PERSON_STATUS" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_ROLE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_ROLE_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_PLAYED_ROLE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ROLE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PERSON_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"START_DATE" DATE, 
	"END_DATE" DATE, 
	 CONSTRAINT "SDR_PLAYED_ROLE_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_PLAYED_ROLE_SDR_PERSO_FK1" FOREIGN KEY ("PERSON_ID")
	  REFERENCES  "SDR_PERSON" ("ID") ENABLE, 
	 CONSTRAINT "SDR_PLAYED_ROLE_SDR_ROLE_FK1" FOREIGN KEY ("ROLE_ID")
	  REFERENCES  "SDR_ROLE" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_PLAYED_ROLE_STATUS" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_PLAYED_ROLE_STATUS_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_PLAYED_ROLE_STATUS_HISTORY" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PLAYED_ROLE_STATUS_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PLAYED_ROLE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ADATE" TIMESTAMP (6), 
	 CONSTRAINT "SDR_PLAYED_ROLE_STATUS_HI_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_PLAYED_ROLE_STATUS_HI_FK1" FOREIGN KEY ("PLAYED_ROLE_ID")
	  REFERENCES  "SDR_PLAYED_ROLE" ("ID") ENABLE, 
	 CONSTRAINT "SDR_PLAYED_ROLE_STATUS_HI_FK2" FOREIGN KEY ("PLAYED_ROLE_STATUS_ID")
	  REFERENCES  "SDR_PLAYED_ROLE_STATUS" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_TOKEN_TYPE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"CODE" VARCHAR2(50) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(500), 
	 CONSTRAINT "SDR_TOKEN_TYPE_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_TOKEN" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"VALUE" VARCHAR2(100) NOT NULL ENABLE, 
	"TOKEN_TYPE_ID" NUMBER(*,0) NOT NULL ENABLE, 
	 CONSTRAINT "SDR_TOKEN_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_TOKEN_SDR_TOKEN_TYPE_FK1" FOREIGN KEY ("TOKEN_TYPE_ID")
	  REFERENCES  "SDR_TOKEN_TYPE" ("ID") ENABLE
   )
/
CREATE TABLE  "SDR_TOKEN_REFERENCE" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"TOKEN_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"ANNOTATION_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PROBABILITY" BINARY_DOUBLE, 
	"ACOUSTIC_SCORE" BINARY_DOUBLE, 
	"OFFSET" NUMBER(*,0), 
	 CONSTRAINT "SDR_TOKEN_REFERENCE_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "SDR_TOKEN_REFERENCE_SDR_A_FK1" FOREIGN KEY ("ANNOTATION_ID")
	  REFERENCES  "SDR_ANNOTATION" ("ID") ENABLE, 
	 CONSTRAINT "SDR_TOKEN_REFERENCE_SDR_T_FK1" FOREIGN KEY ("TOKEN_ID")
	  REFERENCES  "SDR_TOKEN" ("ID") ENABLE
   )
/

CREATE UNIQUE INDEX  "SDR_ANNOTATION_PK" ON  "SDR_ANNOTATION" ("ID")
/
CREATE UNIQUE INDEX  "SDR_ANNOTATION_STATUS_HIS_PK" ON  "SDR_ANNOTATION_STATUS_HISTORY" ("ID")
/
CREATE UNIQUE INDEX  "SDR_ANNOTATION_STATUS_PK" ON  "SDR_ANNOTATION_STATUS" ("ID")
/
CREATE UNIQUE INDEX  "SDR_ANNOTATION_STATUS_UK1" ON  "SDR_ANNOTATION_STATUS" ("CODE")
/
CREATE UNIQUE INDEX  "SDR_ANNOTATION_TYPE_PK" ON  "SDR_ANNOTATION_TYPE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_ANNOTATION_TYPE_UK1" ON  "SDR_ANNOTATION_TYPE" ("CODE")
/
CREATE UNIQUE INDEX  "SDR_CONTENT_STATUS_HISTOR_PK" ON  "SDR_CONTENT_STATUS_HISTORY" ("ID")
/
CREATE UNIQUE INDEX  "SDR_CONTENT_STATUS_PK" ON  "SDR_CONTENT_STATUS" ("ID")
/
CREATE UNIQUE INDEX  "SDR_CONTENT_TYPE_PK" ON  "SDR_CONTENT_TYPE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_CONTENT_PK" ON  "SDR_CONTENT" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_PK" ON  "SDR_DOCUMENT" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_STATUS_HISTO_PK" ON  "SDR_DOCUMENT_STATUS_HISTORY" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_STATUS_PK" ON  "SDR_DOCUMENT_STATUS" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_TYPE_PK" ON  "SDR_DOCUMENT_TYPE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_DOCUMENT_TYPE_UK1" ON  "SDR_DOCUMENT_TYPE" ("CODE")
/
CREATE UNIQUE INDEX  "SDR_LANGUAGE_PK" ON  "SDR_LANGUAGE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_LANGUAGE_UK1" ON  "SDR_LANGUAGE" ("CODE")
/
CREATE UNIQUE INDEX  "SDR_PERSON_PK" ON  "SDR_PERSON" ("ID")
/
CREATE UNIQUE INDEX  "SDR_PERSON_STATUS_HISTORY_PK" ON  "SDR_PERSON_STATUS_HISTORY" ("ID")
/
CREATE UNIQUE INDEX  "SDR_PERSON_STATUS_PK" ON  "SDR_PERSON_STATUS" ("ID")
/
CREATE UNIQUE INDEX  "SDR_PERSON_STATUS_UK1" ON  "SDR_PERSON_STATUS" ("CODE")
/
CREATE UNIQUE INDEX  "SDR_PLAYED_ROLE_PK" ON  "SDR_PLAYED_ROLE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_PLAYED_ROLE_STATUS_HI_PK" ON  "SDR_PLAYED_ROLE_STATUS_HISTORY" ("ID")
/
CREATE UNIQUE INDEX  "SDR_PLAYED_ROLE_STATUS_PK" ON  "SDR_PLAYED_ROLE_STATUS" ("ID")
/
CREATE UNIQUE INDEX  "SDR_ROLE_PK" ON  "SDR_ROLE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_TOKEN_PK" ON  "SDR_TOKEN" ("ID")
/
CREATE UNIQUE INDEX  "SDR_TOKEN_REFERENCE_PK" ON  "SDR_TOKEN_REFERENCE" ("ID")
/
CREATE UNIQUE INDEX  "SDR_TOKEN_TYPE_PK" ON  "SDR_TOKEN_TYPE" ("ID")
/
CREATE UNIQUE INDEX  "SYS_IL0000014004C00003$$" ON  "SDR_CONTENT" (
/
CREATE UNIQUE INDEX  "SYS_IL0000014020C00003$$" ON  "SDR_ANNOTATION" (
/

 CREATE SEQUENCE   "SDR_ANNOTATION_CONTENT_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_ANNOTATION_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_ANNOTATION_STATUS_HIS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_ANNOTATION_STATUS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_ANNOTATION_TYPE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_CONTENT_STATUS_HISTOR_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_CONTENT_STATUS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_CONTENT_TYPE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 23 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_DOCUMENT_CONTENT_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 57 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_DOCUMENT_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_DOCUMENT_STATUS_HISTO_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 50 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_DOCUMENT_STATUS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 24 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_DOCUMENT_TYPE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 23 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_LANGUAGE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1885 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PERSON_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 364 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PERSON_STATUS_HISTORY_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 281 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PERSON_STATUS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PLAYED_ROLE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 301 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PLAYED_ROLE_STATUS_HI_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 341 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_PLAYED_ROLE_STATUS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_ROLE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_TOKEN_REFERENCE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_TOKEN_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "SDR_TOKEN_TYPE_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE
/

CREATE OR REPLACE TRIGGER  "SDR_ANNOTATION_STATUS_HIS_TRG" 
 BEFORE INSERT ON SDR_ANNOTATION_STATUS_HISTORY 
FOR EACH ROW 
BEGIN
  SELECT SDR_ANNOTATION_STATUS_HIS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_ANNOTATION_STATUS_HIS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_ANNOTATION_STATUS_TRG" 
 BEFORE INSERT ON SDR_ANNOTATION_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SDR_ANNOTATION_STATUS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_ANNOTATION_STATUS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_ANNOTATION_TRG" 
 BEFORE INSERT ON SDR_ANNOTATION 
FOR EACH ROW 
BEGIN
  SELECT SDR_ANNOTATION_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_ANNOTATION_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_ANNOTATION_TYPE_TRG" 
 BEFORE INSERT ON SDR_ANNOTATION_TYPE 
FOR EACH ROW 
BEGIN
  SELECT SDR_ANNOTATION_TYPE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_ANNOTATION_TYPE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_CONTENT_STATUS_HISTOR_TRG" 
 BEFORE INSERT ON SDR_CONTENT_STATUS_HISTORY 
FOR EACH ROW 
BEGIN
  SELECT SDR_CONTENT_STATUS_HISTOR_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_CONTENT_STATUS_HISTOR_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_CONTENT_STATUS_TRG" 
 BEFORE INSERT ON SDR_CONTENT_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SDR_CONTENT_STATUS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_CONTENT_STATUS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_CONTENT_TYPE_TRG" 
 BEFORE INSERT ON SDR_CONTENT_TYPE 
FOR EACH ROW 
BEGIN
  SELECT SDR_CONTENT_TYPE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_CONTENT_TYPE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_DOCUMENT_CONTENT_TRG" 
 BEFORE INSERT ON SDR_CONTENT 
FOR EACH ROW 
BEGIN
  SELECT SDR_DOCUMENT_CONTENT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_DOCUMENT_CONTENT_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_DOCUMENT_STATUS_HISTO_TRG" 
 BEFORE INSERT ON SDR_DOCUMENT_STATUS_HISTORY 
FOR EACH ROW 
BEGIN
  SELECT SDR_DOCUMENT_STATUS_HISTO_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_DOCUMENT_STATUS_HISTO_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_DOCUMENT_STATUS_TRG" 
 BEFORE INSERT ON SDR_DOCUMENT_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SDR_DOCUMENT_STATUS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_DOCUMENT_STATUS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_DOCUMENT_TRG" 
 BEFORE INSERT ON SDR_DOCUMENT 
FOR EACH ROW 
BEGIN
  SELECT SDR_DOCUMENT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_DOCUMENT_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_DOCUMENT_TYPE_TRG" 
 BEFORE INSERT ON SDR_DOCUMENT_TYPE 
FOR EACH ROW 
BEGIN
  SELECT SDR_DOCUMENT_TYPE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_DOCUMENT_TYPE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_LANGUAGE_TRG" 
 BEFORE INSERT ON SDR_LANGUAGE 
FOR EACH ROW 
BEGIN
  SELECT SDR_LANGUAGE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_LANGUAGE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PERSON_STATUS_HISTORY_TRG" 
 BEFORE INSERT ON SDR_PERSON_STATUS_HISTORY 
FOR EACH ROW 
BEGIN
  SELECT SDR_PERSON_STATUS_HISTORY_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PERSON_STATUS_HISTORY_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PERSON_STATUS_TRG" 
 BEFORE INSERT ON SDR_PERSON_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SDR_PERSON_STATUS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PERSON_STATUS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PERSON_TRG" 
 BEFORE INSERT ON SDR_PERSON 
FOR EACH ROW 
BEGIN
  SELECT SDR_PERSON_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PERSON_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PLAYED_ROLE_STATUS_HI_TRG" 
 BEFORE INSERT ON SDR_PLAYED_ROLE_STATUS_HISTORY 
FOR EACH ROW 
BEGIN
  SELECT SDR_PLAYED_ROLE_STATUS_HI_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PLAYED_ROLE_STATUS_HI_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PLAYED_ROLE_STATUS_TRG" 
 BEFORE INSERT ON SDR_PLAYED_ROLE_STATUS 
FOR EACH ROW 
BEGIN
  SELECT SDR_PLAYED_ROLE_STATUS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PLAYED_ROLE_STATUS_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_PLAYED_ROLE_TRG" 
 BEFORE INSERT ON SDR_PLAYED_ROLE 
FOR EACH ROW 
BEGIN
  SELECT SDR_PLAYED_ROLE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_PLAYED_ROLE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_ROLE_TRG" 
 BEFORE INSERT ON SDR_ROLE 
FOR EACH ROW 
BEGIN
  SELECT SDR_ROLE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_ROLE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_TOKEN_REFERENCE_TRG" 
 BEFORE INSERT ON SDR_TOKEN_REFERENCE 
FOR EACH ROW 
BEGIN
  SELECT SDR_TOKEN_REFERENCE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_TOKEN_REFERENCE_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_TOKEN_TRG" 
 BEFORE INSERT ON SDR_TOKEN 
FOR EACH ROW 
BEGIN
  SELECT SDR_TOKEN_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_TOKEN_TRG" ENABLE
/
CREATE OR REPLACE TRIGGER  "SDR_TOKEN_TYPE_TRG" 
 BEFORE INSERT ON SDR_TOKEN_TYPE 
FOR EACH ROW 
BEGIN
  SELECT SDR_TOKEN_TYPE_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/
ALTER TRIGGER  "SDR_TOKEN_TYPE_TRG" ENABLE
/

